package com.wontube.smr.bo.constants;

/**
 * @author tanggf(2012-8-2)
 *
 */
public class StandarDramaGenres {
	//public final static String CHINIESE = "Chinese";
	//public final static String JAPANESE = "Japanese";
	//public final static String KOREAN = "Korean";
	//public final static String SINGAPOREAN = "Singaporean";
	public final static String ACTION = "Action";
	public final static String COMEDY = "Comedy";
	public final static String CRIME = "Crime";
	public final static String FAMILY = "Family";
	public final static String FOOD = "Food";
	public final static String HISTORICAL = "Historical";
	public final static String HORROR = "Horror";
	public final static String MARTIAL_ARTS = "MartialArts";
	public final static String ROMANCE = "Romance";
	public final static String THRILLER = "Thriller";
	
	public static String[] getAllDramaGenres(){
		return new String[]{ACTION, COMEDY, CRIME, FAMILY, FOOD,
				HISTORICAL, HORROR, MARTIAL_ARTS, ROMANCE, THRILLER};
	}
	
	public static void main(String[] args) {
		StringBuilder sb = new StringBuilder("INSERT INTO genre(id, genre_name, category, version, display_name)\n VALUES");
		int index = 0;
		for (String g : getAllDramaGenres()) {
			String s = ++index + "";
			if(index < 10){
				s = "0" + index;
			}
			sb.append("('manual_drama_" + s + "', '" + g + "','Drama',now(),'" + g + "'), \n");
		}
		
		System.err.println(sb.toString());
	}
}
